"NightShot" or "SuperNightShot" mode have a built-in infrared emitter that allows monochrome video capture in zero visible light. Check the HDR-CX550 series. The throw of the built-in IR emitter is effectively about 6-8 feet.
Hey - I was looking for a small digital video camera that used either SD or compact flash media that has the night vision feature. I had an old sony dv tape that had night vision but it broke. So far, the only thing I found was a bell and howell (a brand I'd never heard of) DNV900HD.
I purchased the camera. The night vision works but when you play the video, there is a very loud mechanical whirring and ticking when using the night vision. You cannot hear it when you record. It is only on playback and it is only when using the night vision.
Can does anyone know of another camera that has nightvision?
Thanks,
Ro

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic