The mayor hopes it would replace the optional £1 per night city visitor charge