Phoenix gets its water from the Salt and Verde Rivers, the Colorado River and ground water (wells). SRP (Salt River Project) manages the Salt and Verde Rivers and CAP (Central Arizona Project) manages the water from the Colorado.
Some interesting data can be drilled into here in the Power BI report: https://new.azwater.gov/ama/ama-data