N150 by itself doesn't generate any noise, but the cooling fans probably will. There are some fanless N150 solutions that are perhaps of interest? Though they are likely at a higher price point. I'm too lazy to copy and paste a link here, but search for "fanless N150" for some references.
My brother went looking for an N100 with the quietest fan, and gave it to me for Christmas two years ago. It has been an excellent little desktop with no discernable noise that I can tell. Morefine M8S, fwiw.
The N150 is only really useful with active cooling or a chunk of metal bolted to it, and most manufacturers will pick the cheapest possible fan, so yes, there will be some noise.