It depends on the game/application probably. On the cpu heavy titles your cpu will be the bottleneck. On the GPU heavy titles the GPU will be the bottle neck.
The thing is, you can never avoid having a bottleneck. At some point, one component in your computer will be the slowest, causing the rest to run at its pace. the only thing you can do is to move the bottlenecked speed far enough up so that it is not noticable/detrimental to performance.
Judging from your question however, I believe you mean "Will my CPU become the bottleneck causing my GPU to run below its maximum potential?"
Again the answer lies in your application. When faced with a low GPU load such as low graphics settings in a CPU bound game like skyrim, your CPU will probably be the bottleneck. When faced with a high GPU load such as high graphics settings in a GPU bound game like metro, your GPU will become the bottleneck.
Real life performance will depend on your settings, but I think that in most cases you will be able to crank your graphics settings to a reasonably high setting so that you experience a GPU bottleneck in most games while still getting your desired FPS.
A good point of reference would be your current experiences. If you currently experience a GPU bottleneck, you will probably be able to crank up your graphics settings reasonably high so that your GPU remains the bottleneck. In this case your FPS should always be able to stay at or above your current levels too. If you experience a CPU bottleneck now, I'd recommend upgrading your CPU since while you may be able to get better graphics detail with the new card, your FPS will remain at or below your current level with it.