Nikon D700
Check out this clip on Flickr. Looks like the Nikon D700 would be a great camera to use to take photos in the Haunted Mansion.
The only downside to this camera is that it cost about $1,700! There's probably some other camera that can do excellent night mode and has an interval timer.