"Cadillac Desert" is a good read to see how bonkers the water system can be (and was devised to be) in the US West, because it basically tries to turn the desert into a garden. The only problem is that there's just not enough water to do that.
Another good story in the New York times: https://www.nytimes.com/interactive/2023/08/28/climate/groun... (which was discussed in HN, as well: https://news.ycombinator.com/item?id=37306841 )