Well, a lot of the people who can't afford to live in SF, but would like to, still live in California, consuming California water. They just live farther out in the north, east, or south bays.

Of course, if SF actually had 3, 5, or 10 times the population it does today then there would probably have to be a lot of infrastructure changes too. But the limit probably wouldn't be available water for residents.