I'm a straight female and I have to tell you, just go for it! To heck with what others might say with their eyes or comments. I think love is a wonderful thing and meant to be expressed. Even my BF and I get looks when we hold hands or showing any PDA. Nothing more beautiful than love, and the fact that you are of the same sex should never bare advercity. Until we are able to get people to overcome their own prejudices, its up to the rest of us to be there to support the oppressed.
Congrats on your marriage and may you both live a long happy life together.
By the way, I LOVE San Francisco. We just returned from spending a long weekend there with some friends of ours (yes, actually a gay couple). We stayed at their home and had the most amazing weekend. We actually travel regularly with them, and have a blast!