The Pentium D 820
is a dual core LGA775 CPU.
It is will work with any LGA775
motherboard that has an Intel 945
or newer chipset.
Virtually all of these motherboards run DDR2, only a few of the latest supporting DDR3.
Did you have a specific motherboard in mind or is this just a general question?