The Tour de France is a “fantastic” opportunity to showcase Caerphilly County Borough next year, bringing in thousands of visitors and investment opportunities.