Microsoft Security Essentials was just rated pretty highly in a magazine review I read. I replaced Avast on a couple of my machines, and it's been great so far. Very low profile and its free.
http://www.microsoft.com/security_essentials/
Programs like Norton or the other big ones take over your machine and are constantly nagging you and sucking up system resources. Stay away from those.