If you build it right, you shouldn't have any splash at all.  The water entry would be under the water surface (this will keep it quieter, too).  Might be a good idea to get a lid just to minimize evaporation and things dropping in the sump.  Another idea to keep it quiet is to have some sort of dampening medium where the entry is.