Large amounts if its a natueral occurance such as a natueral creek that flows thru your property.
I have a fountain that is a bassalt column that stands in a bed or stones,very sculptural.
I cant get all excited when seeing a contrived waterfall in a circilating waterfeature where the property is in an arisd subdivision. Its everyone to their own choice there.
I also have bird baths that attract flying insects as well as birds.