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%?