The eco-luxury resort features 174 guest rooms, suites and villas, including the first over-water villas in the emirate