I've been away for months and have just installed Skyrim on a new computer.

What do I need a Steam account for exactly?

There were talks months ago about being able to download mods from the Steam client. How does it work to download updates and mods?