A little Sony DSC WX220 point and shoot camera I bought at BestBuy. The secret is to bring the ambient lights up a bit so the camera has some light in the whole scene to work with. I use the "night scene" setting on the camera. It lacks manual exposure and aperture but it seems to figure out what to do fairly well.
I have expensive SLR digital cameras that can't compete in night scenes with 159 Dollar pocket cameras or even an I-pad! The smaller CCD chips seem to work better and have a larger depth of field than big, bulky, expensive SLR digital cameras. Maybe this will open up a discussion on shooting night scenes without a lot of grainy looking noise. If you have someone in the family with an I-pad or I-phone get them to try a few shots for you.