The Birmingham Perry Barr scheme was intended to help create a "meaningful legacy" - but the project's management has caused "significant financial loss" for the council