If you're in the peninsula area, then Palo Alto and San Carlos airports are your closest bet. West Valley club operates out of both and has a very large fleet available.
Other clubs at RHV, HWD, OAK, CCR and LVK. Your preference may depend on where you are based. LVK has more reliable weather (and HAF the least), though it's seldom a problem around the Bay area.
I'd suggest visiting some clubs when you arrive and making your choice then.
I fly out of Hayward, but don't use a club.