I personally use Kapersky Internet Security 7.0 which is getting a bit old. They currently have two later versions (2009, 2010) but I prefer to stick with the old software for as long as they support it and simply get a new license each year for the AV downloads just so I don't have to facetiously learn something new.
I'm not sure if the new stuff is similar but if it is then I recommend it.
Basically what I like about Kaspersky is that it only requires 2 relatively small services to be running at all times and the footprint of both is rather small most of the time. If the AV is updating or scanning then of course the memory and cpu requirements can increase dramatically but most of the time the package is fairly innocuous.
You can give their sales support a call and ask them about their nominally required resources, but most AV packages that I've seen seem to require far more services and memory . Pretty much *all* AV/firewall/etc. suites will allow you to download and try for a limited time for free but I prefer to have a good idea of precisely what I want before I install something simply to "try it out."