Sure, it's done all the time. You'll need a reservoir to hold water, a pump in the reservoir, some sort of feature for the water to cascade over with the appropriate plumbing, and support for the feature and camoflage to hide the reservoir. Look up "bubbler" on the web and you should find some examples.

In the "Search" box above, type in pondless and it will pull up alot of past posts. There are pictures and advice, althought they may not be exactly what you are looking for, but it will help you think of ways to go about your project.

didn't even think about trying a "pondless" search. I went to Lowes today to look at their cement tubes. I think my idea could come out awesome; and because the cost would be low, so what if it turns out to be a bad idea. I already have all the pumps, reservoirs, etc I need.