There is a still camera, an older model that can be controlled via the "Remote Cam" program, the model is DSC-FX77. Also, as mentioned there are several camcorders that work with this feature as well. I personally tried the program out using a DCR-TRV80 Camcorder. It was about as James Bond as you can get. You're able to view on the PDA what the camera is aimed at. You can zoom in/out and even pan a little to the left and right when the camera is zoomed in a little. (I don't mean the camera moves, but the lens does.) The camera needs to be a BIP-enabled camera. (Basic Image Protocol)
The image refreshes on your PDA screen good enough and I got about 30+ feet away before I'd lose connectivity. The frequency of the image refresh degraded equally as you moved further away. You're able to capture images & video on the camcorder only. Not to your PDA. Of course I guess you could grab a screen shot, but not quite the same. I'm not sure if I could hear audio from the camera as well.
Coolness Factor = 10
Real World Use = ?
This has been discussed on this forum several times. Here's just one thread:
http://www.cliesource.com/forums/showthread/t-6082.html
Other Options:
You could also use your UX to view a web page that pushes an image to a server. The web page could simply use the Meta Refresh tag to keep reloding and pull the new image at whatever interval you select. I've tried this and it works fine, just ensure you have a reasonably quick Internet connection if you want a rapid refresh.
Another program that's ranks on the "cool factor" is
SpyStillCam. It was developed by Cliepet, a Cliesource member and is unique unto itself in that it reverses the roll of the PDA, so that the UX camera sends the image to a PC. The latest version works quite well.