Hosting the Eisteddfod yr Urdd could be transformative for Newport and “life-changing” for its young citizens, according to senior councillors.