A controversial new hotel on the north coast will bring a “significant boost” to the Northern Irish economy, it has been claimed.