From what I gather many (most?) cities have water "systems". Dirty water is flushed, evaporation and human processes clean it, then we drink it on the other end. It's a continuous renewable cycle. We are reusing the same molecules, not consuming a limited resources. In many cities, water is nearly unlimited. The system just has to be able to cycle enough for the pipes to be full at any given moment.
Some places like California have too much demand, for the rate at which their water cycles, so they have to be careful. But places like NYC or Chicago have nearly unending supplies of sewage to process.
The amount of water on earth today is the same as 4 billion years ago. It doesn't disappear, it just gets dirty.
The water problem is actually an energy problem. There is more than enough water on earth for probably a trillion people. The problem is it's salty, and desalination is extremely energy intensive. If we figure out cheap renewables, or fusion, or just have to pay a greater percentage of our salaries for water, we're really not going to run out.
I know tfa talks about nuclear holocaust but I wanted to discuss regular water issues/fears.