A giant Japanese-designed public artwork that will straddle Sydney's main street was unveiled, dividing opinion with supporters saying it will boost the city's reputation and critics calling it "stupid".