Senior councillors in Newport have distanced themselves from the prospect of introducing a tourist tax.