I'm going to be getting an GTX 970 and a Intel 3rd Generation Core i5-3570K CPU (4 x 3.40GHz, Ivy Bridge, Socket 1155, 6Mb L3 Cache, Intel Turbo Boost Technology 2.0) CPU, this is my first upgrade and I'm not sure what PSU's are compatible, needed?
Any quality power supply will have the necessary pins for just about any graphics card. Exceptions being something like a kingpin card that takes 2 8-pin plus a 6-pin. I'm fairly certainly there isn't a GTX 970 that uses more than two 8-pins (most use two 6-pins I believe), plus most come with molex adapters. Pins won't be any issue on quality PSU's.
Corsair CX mediocre quality unit.
Any 500w+ XFX, SeaSonic, Antec, EVGA GS, G2, B2 unit will do the job.
See - http://www.tomshardware.com/forum/id-2547993/psu-tier-list.html
eg - http://pcpartpicker.com/parts/compare/antec-power-supply-ea550green%2Cantec-power-supply-tp550c%2Cevga-power-supply-220gs0550v1%2Cxfx-power-supply-p1550sxxb9/