All we hear is water trickling into the overflows, the pumps, sump, and the rock tank is on the other side of the wall. I took the garage in for a playroom/fish room so the tank is in the wall between the two rooms. As for cleaning it, I made the shelf over the tank so I could take it down and I can get to the front. The back well just walk into the fish room and there it is.
I just got a fish tank to do just that, I'm going to build a headboard to put it in. My plan is to make the frame so that the mattress will slide down away from the headboard for easier access. I really like this idea it's awesome!