Chief Executive of Historic Environment Scotland resigns