Hotels like the Atlantis, The Palm in Dubai have pioneered the concept and you can now win a stay in one of their underwater suites.