Council spent £1m clearing 5,000 fly tipping cases