In the semi-arid regions of northern Mexico, where water scarcity forces a single reservoir to sustain irrigation, fisheries, and domestic supply, water quality is usually assessed at the source and rarely at the tap. This study was conducted in a reservoir and in the household taps it supplies, using the same scale of indices. Water quality indices (WQI, EWQI, CCME-WQI), Mexican and international regulatory criteria, irrigation indices, hydrochemical diagrams, geospatial analysis, and a population survey were combined. The reservoir, a low-mineralization calcium-bicarbonate water source, proved suitable for irrigation and as a high-quality habitat, with a longitudinal gradient that clarifies the water toward the dam and concentrates fluoride near the intake. The domestic network showed two independent problems that no aggregate index captures at once: geogenic fluoride above the limit in two of every three taps and fecal coliforms in half of them. The supply chain does not treat the water: lower turbidity at the tap is due to the intake location, not treatment. Clarification, verifiable disinfection, and fluoride removal are the priority interventions.