Unless you are really pushing the CPU, through a heavy load and/or an overclock, the second fan will not really be of that much benefit. It might drop the temperatures by a degree or two.
However, should you go with two fans, it would be ideal to have them at the same RPM and same CFM (same volume of air transfer). That way you're not bottle-necking/chocking one fan's performance with the other.
Plus, the more fans you will have the more noise there will be, unless you don't care about acoustics.