Noise Ninja & Neat Image both do a good job and are available a plugins to PS or stand alone although they are not free. For a comparison of various other options
see here
If shoot in RAW and use PS you can do your noise reduction in Adobe Camera RAW when you convert using the luminance smoothing & colour noise reduction options -
see here