hotel at waters edge