If you're thinking of using the runoff from local rains, consider that California is in a drought. Rainwater isn't going to be all that dependable. There are things called, "Aquifers" - the water table below ground. Rainwater is used to fill this up, and - well: those are also at historical lows because of wells.
Much of the rain that falls is actually evaporated up again, it doesn't run into the ocean.
So, we're still left with a problem of populations that don't have an adequate and cheap water supply. Uh oh.
CA might be in a drought, but it still does get rainfall. Drought != no rain at all, it means less rain than usual.
If you don't get much rain, you have to do everything you can to prevent runoff. There's not much of that in CA and so there are problems. It's partially a drought, and partially bad water management that have caused the problems.
As for desalting the ocean, perhaps building aquifers to retain the run off from rains would be a better solution. They did a great deal of work to send all that water into the ocean, its time they redirected it to where it can stored and used as necessary.