If you're worried about maintenance, forget the fountain. You have to refill them when they get low on water, unless you connect it to your water system and let it refill as needed. And if you are in a freeze zone, you will have to winterize the fountain, which means draining it and putting it up for the winter.
Or you could hire a landscaping service to take care of it.