Hello. The "bay tour" may have referred to a specific route once upon a time, but it only means different things to different people (depending where they launch from). Folks taking off from the west side of the bay tend to believe it means going NWB along 101 because that's what they do. On the east side, those may believe it means going through Oakland.
Regardless, pilots want to TOUR the area north of the bay bridge and TRANSITION TO it along 101 (the bayshore) or through Oakland. Common requests are to transition along 101 or transition through Oakland FOR a bay tour. Once there, you can wander around randomly. Just make sure you don't blunder into B or C without a clearance.
Enroute, I would advise contacting norcal. For example, you can tell them you want to transition along the pacific shoreline to the golden gate and then a bay tour (the term "bay tour" is pretty arbitrary unless you are over the bay north of the bay bridge). This will tell the controller your general idea and you can tweak it from there.
One option to get there is to fly right up the middle of the bay. Expect to stay low (below 1500), go through Hayward and Oakland, and thread between SFO bravo and no closer than 1/2 mile from OAK 30. (We do this quite a bit from HWD - we call this a shoreline departure). But, if it's your first time, it may be a bit much, but just want to toss it out.
Have fun.
