I have i7-4790k and I'm using NH-D15 and its silent.
Even under load i think fan use only about 50% of max speed and mostlikely you will hear GPU fan much sooner than you will even notice NH-D15. But even at max load you will have hard time to notice it in background noise.
At idle/light work i got temperatures around 35-42 and NH-D15 is running on just 250 RPM
under load temps are around 60 and as I said fan is just around 750-800 of its max 1500.
Made small test now with Prime95
- blend test (100% cpu usage) - 55C-65 at 750-1100rpm
- max heat test - 75-77C at 1510rpm, but this is not realistic scenario unless you want to torture your system like that.
So you can expect run 35-60 at 250-800rpm in most of normal situations.
Only possible problem is it's size so check please space in case and also height of your rams. I'm using low profile rams (crucial ballistix) and one is just like 2-3mm from fan. So any bigger ram may have problem, but you may move one of fans up like 0,5cm to give you extra clearing for ram if it's issue.