Being from LA, I am used to a water system that works without needing power. I think most of CA is like that. It was a surprise to lose the water back east when the power went out during a storm.
My city runs on surface water, so we have treatment and then pump to storage tanks. You would have to be out for quite a while to run the city out of water, though - the tanks are large.