A leading childhood cancer charity is to open the country's first holiday retreat in North Yorkshire for families affected by the devastating disease.