Some point and shoot cameras will have the ability to select some settings. What I use is a DSLR which use interchangeable lenses. A Canon Digital Rebel would be the least expensive DSLR and the camera body with a kit lens (non-macro but may still work to get started) and will cost @ $750 for the latest model. The previous model with the same kit lens would be $500. Check out B&H Photo on the web. They are very reputable.
My Reef System: 215g Brick 72x24x29 Dual Overflows | 4x 250w MH | 4x IceCap 39w T5 w/ Actinics | MSX-250 Skimmer | 1/3hp Chiller | 16w UV | Aquacontroller 3 | Lunar Sim | AquaSurf |Tunze Wavebox | 2x Tunze Stream 6101 | MRC Dual Nano Calcium Reactor | GEO Kalk Reactor | Pan World 150PS Pump | Phosban & Carbon Reactors