Looking at a nice handy beacon overhead calculator per AP/per SSID on the same channel the overhead is approximately 3.22% with long preamble, 380b beacon frame size and 102.4ms beacon interval.
You can also change the AP to short preamble, which should halve that overhead as its transmitted at 2Mbps IIRC (instead of 1Mbps of long preambles). It also reduces the overhead on other packets too, as the preamble is transmitted faster. Its small, but it should increase overall network throughput by a percent or two.
Only some 802.11b devices require long preamble, some can do short preamble. All 11g and newer devices support short preamble (and possibly all 11a too? Not sure about that).
In short, unless you need legacy compatibility with really old wireless devices, you can change your AP to short preamble and halve the overhead. You could also increase the beacon invertval to something longer, but that can increase the amount of reassociation time when roaming between access points both because of the longer beacon, but no guarantee that the client will pick up the first beacon that gets sent.
If you really, absolutely must run a ton of SSIDs or APs on the same channel, you can always increase the beacon interval some and I deffinitely recommend short preamble unless you have some darned ancient wireless clients laying around that absolutely must connect (I think I have two 11g clients, my Wii and my wireless printer...the former of which has its wireless disable and the other which is wired in to my network. So in effect, its 11n devices only).
Though...when it comes down to it, unless there is a very good reason, you should really only be running two SSIDs at most, your main one and a guest SSID (if you care to). I only run a single SSID. If a guest needs access to wifi I'll just give them my WLAN password. Its no biggie to me. Everything has access controls anyway, so I don't need to worry about wireless isolation. I am sure it makes it an intsy bit easier for them to get unathorized access to my server...but really not that much easier.