You should look into Topre boards. They are very silent and have great tactile feeling. It’s not as quiet as a MacBook keyboard, but it’s as quiet as you’ll get I think
Got their “low end” typeheaven used after hearing about it here. The sensitivity takes some getting used to, but it encourages hard typers like me to soften up, which is better for speed and comfort. Overall love it, totally silent