Leading figures across the arts, culture and sport will be brought together as part of a new “soft power council” aimed at transforming Britain’s role on the global stage.