For mod downloads, you can check PlanetElderScrolls (free, although it requires a
free account) and TESNexus (not as many mods as PES, less selection).
To make things in the CS, well, that all depends on what you're doing. I'd check out this page though, for some pointers:
http://tamriel-rebuilt.org/?p=modding_data/tutorials
Particularly this one:
http://tamriel-rebuilt.org/?p=modding_data/tuts/dsong/first_room