Local SF estuarial tidal booklets are offered by the local West
Marine stores, local
marinas, etcetera (from free or a dollar) include hourly illustrated tidal
current charts, and somwhere around here I've got a 50-year-old gov't chart. Of course, they all have to be mentally adjusted for the theoretical tidal variations.
I'm not aware of an
internet site graphically showing real-time currents. Winds, yes; currents, no.