Abandoned scooters and a dumped car could be pulled from the River Lagan under a council plan to clean up the “appalling” waterway and turn it into a tourist attraction featuring “little boat tours”.