Another vote for the Olympus Stylus Epic (fixed lens). Great camera, cheap, compact. If you want to take pictures at night you can turn the flash off or use the "Night Scene" flash mode (which I love). Pick up a tabletop tripod as well which should be $10 or less at any camera store.

I bought my Stylus Epic a few years ago for around $100 CDN -- I bet that they're less now. Don't let the sales person convince you to buy one of the zoom or "Deluxe" models! Wasted money and only the fixed lens Stylus Epic comes in sexy black instead of ugly silver!