P4 and Athlon64 is NOT SMP, i.e. you can't run them in dual setup.
The Dual CPU's are....
Athlon MP (can also mod most Athlon XP's) - Cheap and more easy to come by, esp if oyu mod some XP barton chips, BUT old an at the end of its life
Xeon - Very good at video editing and encoding, BUT cost a arm and a leg and is in the middle of its TRUE life span (changing sockets, bus speeds, ect...)
and lastly and what I would go with.....
Opteron Lots of choices in the board's and chips. So perfromance will be based on how much you have to spend. Only real negative, if you can even call it that, is that it of course require Reg. memory.
Dual Opteron boards start at $200 and go up to $600 and higher. Opteron chips can be had for the $1xx range and up to $1xxxx for the top of the line ones.