You won't notice much (if any) difference coming from the x2 5200+ you already have.
For a real improvement in general system performance, increase your memory to 2GB. If you are a gamer, put in a better video card (wait a couple of weeks for the 8800gt from nVidia or a month for the RV670 from AMD). These changes will have a much greater impact on both the feel and overall performance of your system than moving up a couple of notches in processor speed.