Plans for a new hotel in Barnard Castle have been refused by Durham County Council.