Northern Beaches Council in Sydney is under fire after narrowly voting to increase rates by 40 per cent across three years.