Welcome to Geekhack!
Anything except clicky switches (e.g. MX blue, green, buckling springs) should be fairly silent.  And if the bottoming out sound is still too loud, you can install O-rings under the keycaps to dampen the bottom out sound.
Although some of us like that sound 

Any idea what size keyboard you'd like?  Full size?  TKL?  60%?  40%?