After eight years in the making, the hotel has opened its doors – with 795 rooms and suites, 17 restaurants and bars and a focus on superlatives