dslr - How can I make good fountain/waterfall photos?

I have a Canon Digital EOS Rebel XT camera, and I wonder how you could take photos of moving water like rivers, waterfalls and fountains...