The project, described as an “unmitigated disaster” by local councillors, was dramatically scaled back after failing to secure land and running over budget