Water resource management relies heavily on the utilization of decision-making systems to guide the strategic rehabilitation and renovation of infrastructure within water distribution networks (WDNs). This study aims to develop and apply a scripting tool in ArcGIS for decision-making in WDN. It combines a collection of decision support systems, including Geographic Information Systems (GIS) and multi-criteria analysis, for infrastructure renovation and rehabilitation. The research is divided into two main sections. The first focuses on creating and implementing the analytic hierarchy process tool in ArcGIS, while the second discusses its application in the study area, which is the drinking water distribution network of an urban area in Tlemcen, located in the Northwest of Algeria. The study’s results reveal that 25% of the network is in critical condition and require immediate rehabilitation. Sixty-two percentage of the network is classified as moderately urgent, indicating a pressing but less immediate need for intervention. Finally, the remaining 13% of the network requires attention over a longer timeframe for rehabilitation. The main criteria influencing pipe prioritization are material (26% of total weight), laying date (26% of total weight), and pressure (20% of total weight). This developed tool can be easily adapted and applied by engineers and water management officers. It serves as a guide for decision-makers and planners in urban water management in Tlemcen and can be replicated and applied to other areas worldwide.