The council-owned site has become a magnet for fly-tippers despite plans to build 149 new homes on the plot