Council criticised over plan to replace beloved public artwork with 7-metre tall effigy of spaceman created by a former Wall Street trader