The hotly anticipated hotel is finally open, complete with Maldives-style overwater villas, protected mangrove fields and golden beach – we checked in for the weekend