That camera according to: http://www.imaging-resource.com/PRODS/CPP1/CPP1A.HTM Takes SD/MMC cards. Look for a USB to SD/MMC card reader made for the Mac compatible with your installed Mac operating system. If you are sticking with 10.6.8, try to look for a card reader known to be both 10.6 and 10.7 compatible, as those are more likely to be compatible with 10.6.8 than one that just says 10.6 and up
From Nikon, their software is compatible with 10.6.4 and Power PC G4 1GHz or above / PowerPC G5 / Intel Core series / Intel Xeon series according to:
http://imaging.nikon.com/lineup/software/viewnx2/spec.htm.
As for:
http://imaging.nikon.com/lineup/software/capturenx2/spec.htm
has less chance of being compatible, since it doesn't even mention 10.6 Same with:
http://imaging.nikon.com/lineup/software/control_pro2/spec.htm
http://imaging.nikon.com/lineup/software/control_pro/spec.htm
http://imaging.nikon.com/lineup/software/img_auth/spec.htm
iPhoto will take any SD/MMC card as input, and so will most other Mac compatible photography software.
This link below explains your Virtualization software options for Windows.
https://discussions.apple.com/docs/DOC-2741
The good news is your Mac does support Windows virtualization if using their software is a must.