Wonderful location
I thoroughly enjoyed my stay at the Palacio del Rio. Take the river boat tour nearby and they will tell you the cool story of how the Palacio was built in time for the World's Fair. The water/Riverwalk is literally right outside the back entrance of the hotel. The room was clean and modern. I believe all of the rooms have balconies as well so you can enjoy the view. Try the prickly pear margarita at their bar/restaurant (Ibiza I think) on the ground level of the riverwalk.