https://water.ca.gov/Programs/Water-Use-And-Efficiency/Agric...
Stop giving insanely cheap water to large growers with inefficient water usage practices, and the market will quickly right itself and move production elsewhere. At a more sustainable price, with less ecological imbalance.
I suspect that agricultural users are being charged too little, and so they have too little incentive to be efficient. (Or they are pumping groundwater and paying nothing.) And residential users are being charged more than the service really ought to cost.
The only semi-legitimate justification I can come up with is that there are fixed costs associated with water users, and each residential user uses much less water than an agricultural user. But there are better ways to handle this.
I'm rather sure that America/the world could easily survive a California without crops without much fuss.
I quickly googled and it suggests Sacramento pulls from the rivers and underground, SF gets its supply from Hetch Hetchy.