The western US has been fighting over the Colorado river water for years...
There is a basic formula....you build a bunch of stuff, then whine and plead saying, "you've gotta give us enough to support this city/facility we have here." Ask Arizona and Los Angeles how they got most of their supplies....

NO ONE should be allowed to build or farm any area beyond the available water (or energy) resources, and this means absolute limits on size for many communities. Think we have a chance of getting THAT past the construction industry lobbyists?