Upgrading it will help, yes.
The best CPU you can get is this : http://www.amazon.com/dp/B0013DMTAW/?tag=pcpapi-20.
But it's probably out of your budget, and anyway, if you were to get that, you might as well just build a new PC with that money because it's not worth.
What is your budget ?