I personally think any cameras that can record at the highest frame rate possible for the cost. It is possible to use anything from a webcam to a high end astronimical camera but as long as you can record at the highest frame rate. Lower frames are possible but may not get the best resolution.
The main reason for moon and planetary is that the atmospherics reek havoc on the frames captured. The atmosphere is a bit like another lens that changes with wind especially jetstream and causes frames to go out of focus, these frames are no good for the final image.
Oh BTW, USB or Firewaire connections are the easiest to connect as well.
Security cameras require extra wiring power and USB capture hardware and can get a bit messy.
Don't discount the humble entyy-level DSLR Whilst not great for remote planetary (you really need to stack video in this case), they're really excellent for high-resolution lunar. My pref? My Nikon, as it seems to produce more accurate colour than my Canons, but any will do. Low ISO settings mean almost no noise.
Here are a couple of single-frame images I took a while back with my Nikon D40:
Sorry,For widefield moon imaging yes the DSLR is really great too. CCD can be used but being narrow field you would need to mosaic multiple images together.
Most captures are taken in "Prime Focus" The camera requires an adaptor so the telescope becomes the lens , the same goesfor webcams and the like. This is the meost popular method of capturing. There are plenty of examples on this site.
Whilst not great for remote planetary (you really need to stack video in this case), they're really excellent for high-resolution lunar. My pref? My Nikon, as it seems to produce more accurate colour than my Canons, but any will do. Low ISO settings mean almost no noise.
