Fountain pumps are great for running pond fountains and water features. You will need to choose a pump with a high enough flow rate to match the size of your fountain. We have a handy fountain pump calculator here which will help you choose a fountain pump with a large enough flow rate. Some of our fountain pumps come complete with fountain attachments already in the box.
A pond fountain can also help with water movement which helps to prevent mosquitoes from breeding. Mosquitoes tend to like stagnant non-moving water and so the flow of a fountain can help to prevent this from happening.