I want to go from a 478 processor to a bigger one



You and I are in the same boat. To upgrade from your current 478 cpu, you'll need to either find a 478 EE cpu or upgrade the Entire computer to support:

Intel cpu sockets:
LGA 755 (dieing socket)
Lga 1156
Lga 1366

AMD cpu sockets:
AM2 (dieing socket)
AM2+
AM3


For a new computer, You want us to find the parts for a good computer for, then please mention:

Budget
Computer tasks you'll be doing (like gaming, CAD, web surfing, ect.)
retail preference (like newegg or microcenter)