As for video resolution, a CCD camera doesn't necessarily mean you will have good resolution, they range from as low as 1 or less megapixels to 12 or 14 megapixels. I would recomend at least 8. A 12 or above megapixel camera would be ideal, that resolution comapres to a 35mm camera, however you are talking big bucks.

Good luck, and i can't wait to see some pictures.