It all depends on your neighbors. If they are quiet curtious people then you won't hear anything. If they are loud people then you will hear noise. If you have a connecting door you can open the door and place a bath towel on the floor and close the door, this will help with some noise. I have found on occasion corner rooms to be more noisy. You are susceptible now to two walkways instead of one with more people passing by. This opens you up to more noise from kids running, more people talking, and more carts rolling by. I've had corner rooms where I didn't hear a peep, and corner rooms where there's been a ton of extra noise. It all depends on location, and who the people are that are staying at the resort at the same time you are. You could stay in the same room twice and have a great experience the first time and a horrible experience the second.
I downloaded a white noise app on my phone. I put the phone on night mode, plug it in and play a fan sound. I'd highly recommend doing this it helps an awful lot with blocking noise.