I think this will happen for reasons other than water too. So many towns in America were built to be in proximity of train lines who’s location today makes no strategic or economic sense.

I believe many will hit critically low population levels where they can no longer support hospitals, schools, grocery stores, churches, etc