Council plans to repaint 'grotty' Grade II listed bridge after locals threaten to do it themselves