We were in a river view royal room in February and loved the location. The building we were in was close to the bridge by the lobby area and very convenient to the south bus stop.
The royal room was very nice. My only complaint was that it hadn't been upgraded with additional outlets and USB ports, like the rest of the resort rooms. I would bring a power strip if you are going to be in a royal room.
We did hear boat horns in the river view room.
Dogs aren't allowed in the royal rooms - except - of course - service dogs. We didn't see or hear any dogs when we were there in February.