Landmark 1930s building has been blighted with failed plans for 40 years but now includes mix of offices, flats and retail