The great majority of water usage in California is for agriculture, not "coastal cities." Things like drip irrigation and not growing alfalfa in the desert are far more realistic (and cheaper) than what you are proposing. This is a solvable problem, even with climate change, but there aren't going to be any silver bullets.