+1 for the minoura, I’ve an older model and it’s acceptably quiet, quieter than dishwasher/washing machine etc.
Buy a big 18″ fan from screwfix too, the type you see in Gyms and plasterers use to dry out rooms, they’re £30 or so, but will stop you turning into a soaking wet sweaty mess (just open the window and close the door to let the moisture out).
To deaden the noise I mount mine on a layer of old magazines on top of a couple of sleeping mats. Anything more solid than magazines like a sheet of wood vibrated and made more noise, I think the paper layers must move independantly and absorb it, and just the cary mat compressed so it just rested on the floor.
Trainerroad is good for motivation. Magnetic resistance is more consistent for that, but fluid trainers are quieter (at the expense of consistency as the oil warms up).