An abandoned resort on one of Queensland’s most idyllic islands will be returned to the state after more than a decade of failed promises.