The only reason it is beyond capacity is because the ability to expand capacity has been blocked. The bay is nowhere near maximum possible density.
I very much doubt SF is limited in expanded by water pipe capacity. Total water use, sure, but people use less water in a city then the suburbs anyways so it will be a net savings of water.