Sure, you could get a traditional fountain to go in front of your palatial mansion, but that's what all the other rich guys are doing. You want to be a true original, don't you? If so, take a look at this stunning Vortex Fountain.
The Vortex Fountain looks like a free-standing column of water with a spinning whirlpool in the center, and that's not far from the truth. It's a large acrylic polymer cylinder which allows an air-core vortex to form as water is pumped in a circular motion. It's not cheap to make nor is it cheap to run, as it requires a pretty serious water filtration system. But really, if you're the type of person who would get one of these, you don't care about price.