A historic Grade II*-listed building in Yorkshire, is set to be transformed into luxury holiday accommodation.