San Francisco's water comes from https://en.wikipedia.org/wiki/Hetch_Hetchy.

California has plenty of water for the humans. Whether we have enough for the current scale of industrial farming into the future is uncertain.