I bought a ceiling fan for the bedroom a couple of months ago. On the advice of my sister, I bought this one:
https://www.diy.com/departments/col...Ho7fMOF_wNfgZQDgYqwaAtn2EALw_wcB&gclsrc=aw.ds
It is fantastic. It sits above the foot of our bed, so the airflow is nicely on us. The fastest setting moves a lot of air - fairly noisy, but still quieter than a normal desk or pedestal fan, and has made the warm nights recently very bearable. The middle setting is ideal most of the time, very quiet but still moves a lot of air.
However, since fitting it, I don't actually think I've ever turned if off; on it's slowest setting it's essentially silent, so even for the few weeks recently where it hasn't been warm enough to warrant needing a fan, I have just left it on slowly spinning all the time to keep the air moving, as our bedroom is a little small and stuffy. I've found it quite pleasant to have a constant slight draft of moving air, and I think I've generally slept better as a result. It also has a reversing switch would apparently aids heating during the winter.
The only downside is that our ceiling isn't particularly high, so I have to be careful if I take a shirt or jumper off in the bedroom, in case I reach up too far and lose a hand