Bengaluru, Beijing, Mexico City among global cities heading towards Day Zero — when taps will run dry.