What sort of night photos do you want to achieve? Do you want to capture the scenery of the parks at night? Candid photographs of your family in low-light conditions? Fireworks? Night photography offers some of the best opportunity to capture vivid colours and compelling images, but each situation will require a different plan of attack. It helps to understand a few basic things about photography before making your decision:
In very simple terms, a camera regulates the amount of light that enters your image in 3 ways:
- Shutter Speed: Just like it sounds... the amount of time the shutter opens for. Measured in fractions of a second. (1/60, 1/200, 1/1000, etc.)
- Aperture: How wide the shutter opens. Slightly more complex to explain this measurement, but know that a lower number indicates that the shutter will open wider. The bigger the hole, the more light gets in. (f1.4, f2, f2.8, f4, etc.)
- ISO: How light-sensitive the sensor or film is. The greater the number, the quicker the sensor or film will react to the light that the shutter lets in, but higher ISO tends to result in poorer image quality and graininess. (ISO 100, 200, 400, 800, 1600, etc.)
Photographers use these three variables differently depending on the subject and lighting situation. For example: when shooting sports or fast moving subjects, they know they will need a fast shutter speed so the subject is not blurred. Since that would reduce the amount of light hitting the sensor or film, they will adjust the other variables of aperture and ISO to compensate. By contrast, a point and shoot camera doesn't really know what you're trying to photograph, so it takes whatever information it can get from its meters and tries to balance the 3 variables to give you decent photos in most common situations. That's okay for daytime snapshots, but definitely less than optimal when shooting at night, as I'm sure you know from experience! The better the P&S camera, the more flexible it will be... but you'll still need to give it some info in order for the computer to determine the best settings for your photograph, because no camera is smart enough to know exactly what image you're trying to capture.
If you want to get a great point-and-shoot, look for one that has a really good quality lens with a wide aperture (some high-end compacts go to f1.8 or even f1.4) and features that you can enable to help you shoot in low-light conditions. There are a lot of trade-offs when camera manufactures build compact cameras, so in addition to aperture, there are bunch of other factors to compare like sensor size (bigger is usually better) and other technical factors that make my head spin when I try to figure out which camera is best. Generally though, a great lens will make a greater impact on a camera's performance than small differences in sensor size and resolution.
When you find a camera that you're interested in, look for reviews on CNet.com, DPReview.com, and other photo/technology websites to see how that camera stacks up against others in it's price category. If I were looking to purchase the kind of camera you're describing, I would consider the Panasonic LX7 as one of my choices and then compare it to a few similar models. (One informative review here:
http://www.itproportal.com/2012/12/28/panasonic-lumix-lx7-vs-canon-7d/) From what I've seen, the LX7 has a pretty impressive iHDR feature that I think would be useful for Disney at night. See this review and scroll down to the iHDR sample pictures:
http://www.cameralabs.com/reviews/Panasonic_Lumix_DMC_LX7/
A DSLR can be bulky to carry around and can be intimidating to use when you first get started, but they are the most flexible and can adapt to just about any shooting condition. KenRockwell.com is a fantastic resource to look at if you consider getting a DSLR.