The elaborate further on what Nicky said, point and shoots have "optical zoom" and "digital zoom". A typical camera has optical zoom to about 3x (about 100mm equivalent) but might then have a digital zoom to 10x... it's the digital zoom that is completely useless. This is usually indicated by a pause and colour change on the display when zooming. Stop at the pause.
You can get some models of compacts that have a 10x or more optical zoom (about 300mm equivalent) from which you can expect to get a decent zoomed shot.
I'm a Canon fan.
What's your budget for the SLR and lenses? This will make a great deal of difference when it comes to what model and lens combo to recommend. You have everything from the base model body and lens kit to fully professional and L series glass, and everything in between to choose from.
Remember, there's no better site for camera comparison and reviews than DPreview. Here's the Canon models page...
Canon Digital Cameras: Digital Photography Review
Your most current Canon model selection would be in order of low to high cost...
EOS 500D (Rebel T1i) << entry level, also shoots 1080 movies at 20fps, 720 at 30 fps (all others after this have 1080 at full 30fps capability)
50D as pointed out above, though getting a little long in the tooth now I think.
EOS 7D << semi pro
EOS 5D MKII << pro, full frame sensor, comes with a 24-105mm L series lens in the full kit, same lens as I own on my older 400D.
EOS 1D MKIV << the uber model
The kit lenses on the entry models tend to be kind of sucky. I would buy the body kit only and get a lens separate. This is where the major budgetary concerns come into play, because high end lenses can easily surpass the cost of the camera body.
The movie capabilities of the higher end models can't be overlooked. There's a whole aftermarket of steady cam kits, follow zooms, etc. as they are quite capable of shooting Hollywood quality footage. A lot of amateur film makers are using cameras like the 5D to produce some stunning video.