Sky & Telescope just reviewed the LXD Schmidt-Newtonians and found them capable of "beginning" astrophotography. If I were going to use that line, I for one would go with the smallest (6", or possibly the 8"), since they all use the same mount, and the 10-inch would be a strain on that mount, especially if you have to add a guide scope (which you do, unless you have a CCD with a build-in autoguider). A sturdy mount is key.
I don't have experience with the CCD you mentioned. I'm mostly into film photography with my LX200 GPS 10-inch, or with a small refractor mounted on it. But it depends on what you want. If you want planetary images, the exposures are short and mount stability is slightly less crucial. Deep-sky requires longer exposures, or stacking of many short ones. You have to match the pixel size of the CCD to the scope AND to the targets you want. Not every scope/CCD combo is suitable for all targets. Check out the Sky & Telescope web site for some introductory information on deep-sky photography in general.