No such thing as a stupid question!
It depends what you're trying to do really. If you're looking for quiet, have it under the surface, but if you'd like some extra oxygen in your water (if it's above the surface, you get bubbles, right?), then let it make a splash