Climates of Tamriel is currently available on the Steam Workshop! Looks interesting, to say the least.
I did try the above mod but found the night time lighting way too dark. Nice sunsets though, here's one I captured:
Here's a couple more although not with the above mod installed but others I'll provide the list for..
Here is the list of mods currently running. You'll find all these mods here: Skyrim Nexus - Skyrim mods and community