A CPU upgrade really isn't cost effective and your options would be very limited anyway for a minimal change in performance. Best bet is to max the RAM for your system. You could also add an updated AGP video card, but once again, it will be questionable in terms of cost for performance gained.
My recommendation. Start squirreling away money to buy a new system and live with what you have until then. If you do anything with this, add memory.