I would for sure make a trip to Monterey. I think it is only about an hour and a half from San Francisco. Would be a sweet daytrip!!
Aquarium of the Bay - San Francisco
http://www.aquariumofthebay.com/
Monterey Bay Aquarium - Monterey
http://www.montereybayaquarium.org/