as long as your mobo supports it, the gain should be pretty noticeable.
when i upgraded, i went from an athlon 5200+ to a phenom ii 550, and it made a hell of a difference (as much as 30fps or more gain in some games)
CSS is pretty CPU dependant, so i would imagine a pretty big performance boost.