Mayors across England are to be given the power to charge a tourist tax on overnight stays which would apply to British and foreign visitors alike.