Shayne, I use layers in CS2 for noise reduction, but I'd be very surprised if you needed to use this technique because as Charlotte says Lightroom has good facilities for noise reduction. For videos about Lightroom, have a look here at
Adobe TV's Lightroom episodes. The one on noise reduction is about half way down the page under the heading of "Sharpening and Noise Reduction". If you are still not convinced, then I think David's suggestion of posting an image that you aren't happy with is a good idea, perhaps in the post processing forum.
So if the noise reduction is so good in Lightroom why don't I use it? First, I do use Lightroom's default colour noise reduction when importing images into Lightroom. This gets rid of all the colour noise in all the images I have processed in Lightroom, from several cameras. The reason I don't use Lightroom's luminance noise reduction is that I deal with particularly noisy images captured in "photographically hostile" environments using cameras with very small (P&S sized) sensors which are noisy, and the one I use is particularly noisy, sometimes even at base ISO.
Lightroom can get rid of the noise, but it destroys too much detail and and subtle tonality for my purposes. I am dealing with macros/close-ups, often of finely structured invertebrates and delicately shaded flowers. I need to reduce the noise selectively in plain backgrounds, which is where it shows up most. You can use the adjustment brush in Lightroom to apply noise reduction to a selected area (this might be new in Lightroom 5), but for some reason the noise reduction available via the adjustment brush is nowhere near as strong as that you can use on the whole image, and not strong enough for my purposes.
Instead, I process images in Lightroom without applying any noise reduction beyond the import colour noise reduction and then send the image over to CS2 for finishing off (resizing and sharpening, and a couple of minor things before and after that). If the image is too noisy to use as is, I go back to Lightroom and apply Lightroom's very powerful whole-image noise reduction to the image. I then send that noise-reduced version across to CS2 and add the other (noisy) version to it as a layer. I then paint with the eraser on the noisy layer (or create a layer mask and paint on that) to reveal the noise reduced version in the smooth background areas. For some other areas I may reduce the opacity of the brush I'm using and paint them to give them an intermediate amount of noise reduction.
It sounds complicated and time consuming, but it is surprisingly quick and easy after practising it a few times. But like others here I very much doubt you need to go to the trouble of doing something like this.