it all depends on where you want to live - here's a list of bay area counties: san francisco; north - marin, napa, sonoma; peninsula - san mateo; south bay - santa clara (includes san jose); east bay - alameda, contra costa; east-north: solano (fairfield, vacaville).
marin (mill valley) county is about 15-30 minutes from sf across the golden gate ($5 toll and rising) and is very hilly and foresty and expensive;
across the bay bridge (piedmond, berkeley) is about 15-30 minutes from sf but very trafficky and is known as "very liberal" city(ies)...at least berkeley is and temperature is very moderate year round;
father east bay you go (through the caldecott tunnel - lafayette, moraga, walnut creek), the hotter it gets b/c it's in the valley and a little pricier (lafayette, moraga - the county club setting) but great public schools;
further east/south you go (pleasanton, livermore, san ramon), an hour outside of sf, you have really great neighborhoods, schools and affordable everything;
peninsula (burlingame, san carlos) has moderate temperatures and good public schools and about 15-30 minutes from sf - live off of 280 freeway and you're in a higher-end residential neighborhood with good schools, hwy 101 burbs is more industrial lower-end neighborhoods;
my fave - san francisco..someone mentioned the lottery system but the school board might get rid of that program next year (thank god!). there are plenty of great public schools (i.e. dianne feinstein elementary and lowell high school - rated one of the best in the country) and you've got private schools that could cost up to $30k a year.
the drive times i noted are estimates only and each city/county have great schools so it all depends on what you can afford for housing.
couple of great sites to check out:
http://www.greatschools.net/
http://portal.sfusd.edu/template/default.cfm?page=about
i hope this gives you at least a place to start and good luck to you.