People who throw rubbish out of their cars have been labelled “obnoxious” and “offensive” by a council leader.