But, having grown up in Tucson where there are light pollution laws because of the observatories, I can tell you that seeing it with the naked eye won't show you the colored clouds of dust and whatnot...but you'll see a crapton of stars, and that in and of itself is beautiful.
I'm getting the urge to drive out to the high desert this weekend.
I heard that during the great blackout in NYC a few years back, when folks were camping on the streets and in the parks to escape the heat, people were utterly blown away by the un-light-polluted night sky over Manhattan.
Ahh, another reason why it would not appear this way to the naked eye - they used a filter that would let a specific wavelength of hydrogen show up. Absolutely gorgeous just the same, though.
If the security light is close enough, some night when your neighbor isn't home, hose it down until the bulb cracks.
Best I got so far was this, on an island. EOS 350D, 50/f1.4, 30-sec exposure (noisy as hell). Haven't made it yet to a desert, where the air would be really dry. One day...