The Mayor of Greater Manchester wants to introduce a "proper" tourist tax in the city after a nightly visitor charge raised £2.8m in a year.