I was recently prompted to read 'Cadillac desert' which provides a very interesting summary of the development of water in the west, and the looming challenges. TLDR: it's gonna keep getting worse. Anyway, highly recommend.