Not really. Probably you can find some case where that is true, such as small towns that formerly used now-depleted aquifers, but on a population-weighted basis your typical California city has completely separate rights and infrastructure. Many of the municipal systems have very superior rights, way upstream. Our ancestors were idiots but they knew the rules of the game.