The Warwickshire venue has undergone an extensive makeover and opens its doors to customers this Friday