Massive sculpture by Simon Hitchens, criticised by local campaign group, is three times the size of Antony Gormley’s ‘Angel of the North’