Well I think you're are going to limit yourself to a compact, but you will need to find one with some manual controls, like shutter priority, aperture priority and ISO adjustment, to give yourself some creative control. It would be useful if it's lens started at a nice wide angle focal length like 25mm and be capable of zooming up to a focal length of 250-300mm (10x or 12x zoom).
I wouldn't get too hung up on how many megapixels the camera has, as it's the size of the sensor those pixels are crammed on to that's more important. The bigger the sensor, the better it will perform in lowlight conditions. This is where a DSLR will always out perform a compact because DSLRs have much bigger sensors. It might state that both have the same number of pixels, but on a DSLR each pixel is larger and therefore can capture more of the light passing through the lens in shorter length of time. A compact has only a tiny sensor in comparison and the more pixels they cram on to the sensor the smaller each pixel becomes and hence the time the shutter has to remain open to capture enough light can be as much as ten times longer. It also means it will suffer with noise a lot more as a result.
For the best picture quality, pay more attention to the quality of the lens the camera has. Even with a DSLR, the better the quality of the lens the less distortions you will get from it and your images will appear much sharper. An image stabilizer is also useful to help you combat the effect of shaky hands.
Now if you're looking at Canon's range, take a look at the S90 and SX10iS. Both should perform reasonably well for you, but why not also look at the Panasonic Lumix DMC- ZR1, ZS1 and FX65 too. Lumix cameras use a Leica lens, which is about as good as you can get and score highly in
reviews as you can see
here
Anyway, I hope this has given you some useful insight, but if there's anything you're not sure of, just ask.