There’s nothing macabre or spooky about the 119-room property, whose design team have, with great sensitivity, created a nautical and nice hotel on a site associated with one of the world’s worst maritime disasters