It really depends on your setup.
Do you have a lot of deadspace, and does heat tend to build up in that part of your case? If so, putting on an intake fan might cause enough turbulence to drop temps a bit.
If not, it will not make any difference at all, except for the added noise of another fan.
I don't have an intake fan. I can feel the air getting sucked into the front by the exhaust fan pressure, and adding one never really helped me all that much. Not enough to put up with the sound, anyway.