A council contractor has been caught on camera pooing between parked vehicles in a residential street