You can buy as many fountains as you like – but you need to have built Burns Manor before the fountain can unlock in your decorations menu (until then it’s marked as part of a Quest). Once it’s unlocked, it’s available for $3500.

Personally, I’m going for a bit of a Palace of Versailles look in the grounds of my Burns Manor – and that requires lots of fountains!