For the Bay Area, the charts on this page are interesting: http://sfwater.org/index.aspx?page=69

Particularly this chart on rainfall at Hetch Hetchy (where SF's water comes from): https://infrastructure.sfwater.org/fds/fds.aspx?lib=SFPUC&do...