Mayors and local leaders will be given new powers with a levy on overnight stays as part of a devolution drive to shift power out of Westminster.