Kaspersky Antivirus / Internet Security is the way to go.
It is not a RAM hog, nor a hard drive hog. It is very configurable, very easy to use, and very fast to use. It is endorsed by hackers and casual users, and is the most widely accepted antivirus program available.