Pub-goers oppose council ban on riverside drinking