Why do we still do so much farming in regions that have such marginal water supplies? Are there no better-irrigated places in the US to grow all these crops? Obviously all these farms can't move overnight, and presumably the owners of the farms wouldn't be happy with their revenue moving elsewhere, but it seems necessary.
Has farming been slowly (too slowly?) moving out of these water-strapped regions? Or are they just all sitting there, expecting someone else to bear the brunt of the problem? I know there have been shenanigans with farmers deliberately growing water-hungry crops because the water allocations have always been a "use it or lose it" system. That is apparently changing (far too late, IMO); do we expect this to have a meaningful impact?
Either way, I would suggest that it's a lot easier to move farming activities to regions with a more stable water supply (assuming such regions exist) than it is to move hundreds of cities of people.