Neither is better.
CCD imagers are more expensive to produce; in theory CMOS imagers are cheaper to make. However, CMOS imagers are inherently more noisy due to the supporting circuitry on the chip itself.
Advances in technology and digital signal processing chips have made CMOS imagers better by removing the image noise. In fact, the images from CMOS imagers are now so good that you see them used in high-end cameras and not just point and shoots. CMOS now allows good images to be made for lower costs.
Initially, CMOS was used in point and shoots because it was cheap. At the same time, high end SLRs all used CCD sensors--more expensive, but obviously better image quality at that time. Canon then introduced CMOS to SLRs, relying heavily on their expertise in making the image processing/digital signal processing chips to remove the noise. The result was an extremely high quality image.
These days, there's no real difference in quality between a CCD or a CMOS sensor, and CMOS sensors are cheaper to make, which is why you see them in more cameras, including SLRs. If you're looking for an SLR, buy either kind. For a point and shoot, the key thing to look for is what kind of supporting chip is being used in a CMOS sensor. For example, Canon has its "Digic" chips, which are good for processing images or Panasonic has its "Venus" chips.