Residential and city use is a) a drop in the proverbial bucket (20% of California water use) and b) comes from a completely different system. For the most part it's drawn from snowmelt in the Sierras, and even when drought gets pretty bad it's been sustainable. Fingers crossed it will stay that way.
Really it's farmers who should pay for water, and hard limits on aquifer withdrawal. They'll hate it but there's not enough to go around and I don't see an alternative.
Also worth pointing out that California is an enormous place and what applies to the Central and Imperial Valleys doesn't apply to, say, the San Joaquin Delta. There's no good reason to stop growing rice in the latter, because the acre-feet of water which go into doing so are just going to flow directly into the Bay otherwise.
Maybe we could pay for more of it to be diverted into the Central Valley if there was some sort of profit in it. Water auctions, say.