I'll be in visiting the Bay Area in the near future. Can I rent a room at a dungeon? Any recommendations? Thanks.

Check out Fantasy Makers across the bay from San Francisco in Oakland.

http://www.fantasymakers.com/

If they can't supply what you want, then they can probably refer you elsewhere in The City.
The ladies are well connected in the Bay Area dungeon community.