I think this will happen for reasons other than water too. So many towns in America were built to be in close proximity to train lines, who’s locations 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