ThirstyCats makes a lot of different designs
and they all produce different qualities and volumes of water sounds.
Some can be adjusted to be completely silent
while others have considerable sound and there is every level between.
Further, different designs are suitable to different physical and temperamental characteristics of your cats. Here is a page with videos of several different designs and information on which are suitable for what kind of cat.