Yes. Los Angeles does buy water from some ag rights holders but they also have dedicated supplies. San Francisco and the East Bay have totally separate rights that are upstream of everyone.

I think the main thing to know is that water is not like electricity. There is not a grid. Every municipal system has circumstances completely unique to it.