I have stayed on Destiny's Lido Deck. There is no noise from the deck . The cabins are isolated from the Lido deck by doors and hallways and you hear nothing more than any other cabin. As a matter of fact, because there is only a short "run" of cabins you get very little hallway traffic or noise. Very convenient to pool area and food area.
Actually I would say this was one of the nicer rooms we have ever had. We had a balconey room. The room was the largest regular/non suite room we have ever been in. Bathroom was almost "real" size. As my wife would say, "the shower was actually big enough that you could bend over and pick up the soap". Convenience to pool area was unbeatable and I could go get a cup of coffee or a cold drink without waiting for elevators etc. As I noted above, because there were so few people on the floor , there was very little hallway noise.