If you want a relatively large fountain that's good both indoors and outdoors, the Eucalyptus Fountain may be just the ticket.  Water flows gently from leaf to leaf, so most of the sound occurs when the water falls from the last leaf into the base.  

It comes delivered in 3 pieces, usually in 2 or 3 boxes.  You need only a 1" open-ended wrench for easy assembly.