Residents shocked by 'horrific' fly-tipping