I stayed at Villa Florence. It's only a couple blocks from Union Square. It's also super easy to get on a Trolley to go to Fisherman's Wharf.
I was just there at the end of May for a couple of days. I don't know if they have bigger rooms for your family though...