England’s mayors will be able to invest in transport, infrastructure, and the visitor economy through a new levy on overnight stays.