Modern day water systems will only work for a while, until the water towers run out of backup systems. Still need electricity to pump water up for gravity to pressurize/distribute it.
Not always. Also, a lot of water towers have alternative power sources they can use. More and more, solar panel arrays do this. They work very well despite the lack of constant power output because the water tower itself buffers the need for service.