Steam uses minimal RAM and little to no CPU when running, it is used to launch the game and it merely runs in the background. It uses about as much system resources as MSN messenger, it is hardly going to impact game performance.
Wait? So it's not just for activation? We have to get on it every time we launch the game? Won't that require constant internet?