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.
I know NYC doesn't treat their water at all, but LA doesn't either? 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.
You can't have a city of millions of people and have the water be potable from the tap without testing and treatment