North Sydney Council has voted to nearly double its rates, despite strong opposition from residents.