Simply put, the best way to clean optics is to not let them get dirty in the first place.

I doubt indoor lighting will hurt your ccd. It takes something more like pointing the lens at the sun to generate enough energy to damage one.