The Monterey Bay [1] is the premier Northern California locale for a number of water sports, especially scuba diving [2].
Links:
[1] http://www.moon.com/destinations/california/central-coast/monterey
[2] http://www.moon.com/destinations/california/central-coast/monterey/recreation/scuba