Vallejo City Marina is probably the least expensive in the SF Bay area and I think they have a live-aboard slip open (try for "J" or "K" docks). They do allow pets as well.
The marina is located a block or two from the Vallejo Baylink Ferry terminal.
Another option may be to join a Yacht club...
J/36 "Zero Tolerance"