I got a Tacx one similar to the one in the ebay link above. I think it was £125 from CRC and comes with a remote for 10 levels of resistance.
I use it in the shed and it’s quite hummy, but I think that is mainly as it resonates through the floor of the shed and ‘cos it’s a small wooden box it gets quite boomy.
I imagine with a folded over yoga mat underneath it or something similar it would be a lot quieter – anything to isolate the trainer from the floor.
Make sure you’ve got a towel handy as you’ll sweat buckets. I haven’t bothered with one of those towel thing things to stop your bike getting covered in sweat but might be worth a look.
I use two old phone books to prop my front wheel up to get the bike back on the level again.