The Russian River in Sonoma County is a fairly popular place for bay area residents to kayak, swim and raft. Right now the river is pretty tame since it is a low water year and late in the season.
The beach on the San Francisco Bay (Presidio) side of the Golden Gate bridge is pretty busy and a neat place to just hang out. Baker beach lets you get pictures from the ocean side.