There are a few spots North and around SF area (talking about hour to hour&half driving minimum)
The more popular diving spots are in Monterey/Carmel/Pacific Grove, about 2 hours south of SF.
Point Lobos State Park is great from what I've heard, but you need a reservation for your dive team.
Other sites are:
- Monastery (get a divemaster or local diver for this, it's takes a few lives every year, both local and visiting)
- San Carlos Beach (AKA Breakwater) - popular lovely spot for new and experienced divers
_______ask about the metridium field if you go here.
- Lovers Pt.
- Carmel River
- McAbee Beach
- Various dives off the local charter boats
Have a great trip!