With its south-facing slopes, warmer temperatures and low summer rainfall, the county is ideal to become Britain’s sparkling wine hot spot