Steam Workshop has a "mod subscriptions" framework for auto-updating mods. I'm not up to maintaining subscription auto-updating for my mod.
TES Nexus is another popular site, but I have heard bad things about them a few months ago, something about various mods being infected with malware. It might be cleared up by now, however I'm not trusting TES Nexus just yet after that fiasco.
tl;dr; anyone know any good popular mod hosting services for Skyrim mods besides Steam Workshop and TES Nexus?