The fate of a hotel in North Berwick will be put before Scottish Ministers after East Lothian councillors went against recommendations to approve its demolition.