For CS:GO you really need a high-end CPU, my i3-4160 only manages ~150fps on ultra (with a GTX 970) - but the CPU is the bottleneck, and the same can be said for most source engine 2 games, as the engine is relatively reliant on the CPU, so if possible go for the best CPU you can (i3, i5 minimum).