The problem with pumped hydro is that you need a suitable mountain to do it at a large scale. Those are rare and found mostly outside cities. Does it work at the scale of a water tower?
Yeah, pumped water doesn't work everywhere. I think the water tower wouldn't be economical. The article I linked provides an existing alternative that doesn't require special geography.