I actually have built in tanks on 3 sides of our bed… a lot of people listen to white noise and natural sounds just to be able to sleep… as long as the water level is full enough that the skimmer isn’t too noisy, they actually help us sleep… my lights are on timers, and imo, it’s gentler to wake up to gradually increasing light, than to suddenly wake up to BEEEP… BEEEP… BEEEP…
I’m sure you could set up aquariums that would be bad for you to sleep next to, but just as likely, you could set up aquariums that would help you sleep better…