True "dead silence" would be strapping a Scythe Ninja or Prolimatech Megahalems to the CPU and then not using any fans. Passive cooling is always dead silent. How practical that is, well it probably isn't. Definitely not for 5930k. Everything else is going to make noise. To me, it's more of "what kind of noise" than "how much noise", since my first gen H100i was far from silent, even with Gentle Typhoons, but neither are the Hyper T4 and TX3 I own.
I don't know what OP has in mind for longevity, but an air cooler tower, unless damaged by blunt trauma, will continue to function forever, provided that thermal paste is regularly replaced as it becomes dry and crusty (every couple years?), it gets regularly dusted off (every few months?), and has dying fans replaced. AIO's on the other hand, generally live as long as the pumps do. My personal experience with them is a 22 month lifespan for two AIO's, an H100i and an H110. Some claim 3-5 years. Others arrive DOA. My 5 year old TX3 is still functioning as well as it did on day 1.
Basically, AIO's cool better but live shorter, air coolers live longer but take more space to do its cooling. There are trade-offs for both, neither are going to cool to sub-ambient temperatures. If you live in a place where it's 27C in the summer and you have no AC, temps will suck either way.
Personally, I'd pick air cooling, at the cost of ease of install, for the ease of mind and the set-and-forget mindset you can adopt once it is installed.