The fabrication technology is really irrelivant to the buyer of the camera - it is simply the tool that the manufacturer has selected to use in order to get to a finished product.
The theoretical advantage that CCDs have is that they are simpler devices and typically have a higher fill-rate (ie percentage of the pixel area that actually recieves light). The problem, however, is that manufacturers are very limited in what they can do with these chips - they work in a specific way and there isn't much you can do to counteract that.
CMOS and JFET sensors, on the other hand, provide engineers with a wide range of options in designing the sensors. While their fill rates are typically smaller, they can implement noise reduction and amplification at the pixel level to result in a signal that is just as clean as a CCD. Canon has become quite adept at this, and has made CMOS sensors that can easilly go head to head with the best CCD implementations.
The visible noise level in an image is the result of two factors - the strength of the image signal (good) and the strength of the noise signal (bad). The ratio of these two values, called the signal to noise ratio (SNR) is what is important to the end result. This ballance depends on a lot of variables and the difference between two different CCD implementations is often much larger than the difference between one of those CCDs and a CMOS chip. While CCDs almost always have stronger image signals, CMOS sensors are often more immune to the introduction of noise in the readout phase - as such it isn't a simple matter to discuss.
In short - ignore the sensor type line on the spec sheet as that really doesn't mean anything to end users. Look at the images comming out of each of the cameras you are considering, its feature set, available lenses/accessories, handling, etc. and make a decission based on those factors. Any advantages or disadvantages in a sensor technology will effect the quality of the resultant images, so looking at them will reveal any problems the camera may or may not have. There is no point in making theoretical judgements when you can easilly perform real-world analysis for yourself!