Circulation pumps are ideal for running water features, but all features have varying flows needed to get the desired effect. Sometimes getting the right pump requires a bit of trial and error, but the two main things to focus on to pick the right pump is to have an idea of the flow rate and to know the height you are needing the pump to push up to. Just be cautious, because where the labeling tells you the max head height and the max flow, it doesn't mean you will get that flow from that height. The maximum flow is straight out of the pump and the closer you get to the maximum height the less flow you will get.
Fountain pumps come with an assortment of fountain nozzles, this normally includes a standard spray, double daisy and a mushroom/bell nozzle. The majority of pumps come with a tee piece, which allows you to run the fountain plus another feature or external filter, but this will depend on the size of your pump. Anything below a thousand litres per hour will generally be too small to be able to do two things.