I use the following and you can hardly notice it’s there. The very first time I switched it on I thought it wouldn’t start because I couldn’t hear anything and had to check the processor fan rotating to see it was actually starting up? 
Corsair HX850 (semi passive cooling)
Scythe Mugen 5 PCGH Edition (2 large 120mm fans)
MSI GeForce GTX 1060 (semi passive cooling)
Fully SSD drives. (Only external conventional sata drives to backup and archive audio)
I’ve considered water cooling but that’s only interesting if you want to overclock to the limit and that also needs fans to cool? And these can be even more noisy than a good air cooler?
I run my i9 7900 processor at 4.3 MHZ (stock speed is 3.3 MHZ) and just hear it a little when it’s very hot. Like close to 30c or above. besides that it’s almost dead silent.
Hope this helps?