Councillors say “community is at breaking point” due to road closures for popular multi-day triathlon as route changes proposed — but some locals say event is a “lifeline to our village economy”