you'd really have to decide which make you want to go, Intel or AMD, before someone could give you an opinion. What motherboard will you be using? RAM, GPU, etc? If you're looking for a generic answer, the E8400 will do everything you want, unless your using multithreaded apps, then a quad. You're gonna get faster performance out of Intels, used to be better price out of AMD, but that doesnt even neccessirly hold true anymore.
If you provide a budget, a main uses of what you want a PC to do, and a CPU make option, you'll get more detailed answers.
No offense, but right now, the way you've posed your inquiry, it'll just spin into an Intel vs AMD and Quad vs Dual Core thread.
There's a ton of those in the folder, peruse them.
Penewah!
#1:MSI K9A2 790FX/AMD Phenom 9950BE125w OC 3.12/Xiggie120/Antec1200/HD4870 1GB ASUS/mushkinBlack 4GBDDR2800 /Sammy Spinpoint 640GB&320GB-SATA/PCPC 750W CF Silencer/ LITE-ON & ASUS DVD±R/Vista 64-bit/Dual 22" HannaG Mons/ WD My Book 500GB/Logitech X-530 70 watts RMS 5.1 Black Speaker System /#2:Biostar 780G/AMD 6000+x2/OCZ PlatRev2 2x1GB DDR2800 /Logysis-Acrylic/Vista/Ubuntu 8.1 / Corsair 550W PSU/#3:E8500/Gigabyte P45/HD4850/Xiggie 120/OCZ StlhStrm 700W, CM HAF case/OCZ Plat 2x! 1066