The answer is fairly obvious and simple. Fountain pumps are specifically designed for continuous operation. The equipment will get more wear and tear if you are constantly turning it on and off. The exceptions to the rules are written in the instruction manual, so you should read the document or the manufacturer’s advice carefully.
You should only turn the fountain off during cleaning or if you are going to be away for several days.