The leader of the council at the centre of a dispute about cyclists meeting at a cycling café has vowed to find a “pragmatic compromise.”