Former motel on NSW north coast set for a new lease on life