if it was me, i'd save up and get an entirely new rig.
Pentium D is hot, and i mean hot, how is your temp?
getting a new one, even low end ones will be a lot faster than what you have.
but for your upgrade, it depends on your board, go check what are the supported cpu's, and note the bios version that is needed. You will probably have to flash, good luck