Whose last name did the baby take?

We are planning on the baby having my husband's last name, but I'd like mine to be on the birth certificate, maybe as a second middle name.

If we do that, though, will it have to go on their social security card, etc? It is meaningful to me, but not if it will give them trouble their whole life.