Every major city in southern california dumps raw sewage into rivers and oceans with regularity. There is too much of it to even keep track of. Here is massive one from not even 30 days ago: https://www.latimes.com/california/story/2021-07-12/la-me-po...
There is no municipal grey water systems or mandates. No reasonable person would say anything about southern california's water policy or water history is "responsibly managed". I don't know enough about northern california's situation first hand to offer comment but I would be shocked if it's any better. Oroville remind you of anything?
It is completely true that agriculture consumes many times more water than residential use. California is a complete disaster there too. 25% of irrigable water is diverted to the ocean for the delta smelt, and another 25-40% is controlled by the resnick family's holdings and the sham of the kern county water bank.