Want to download Steam, but I have a question.

What is Steam actually? I see everyone talking about/using it, but I don't know exactly what it is. And is it sweet?