If you want a different look to the game (as if it doesn't look good enough already), I would suggest trying out this:

http://www.skyrimnexus.com/downloads/file.php?id=5253

I haven't personally played Skyrim but, I've used the ENB Series mods on other games (including WoW) and, IMO,
it makes things look amazing and gives everything a whole new look and feel. Beyond giving out that link I don't
know how to make it work in Skyrim or anything like that so if you need assistance getting it working I would
suggest asking on that site.