Brixworth residents have voted in a Liberal Democrat councillor for the first time, after a shock swing saw the Conservatives lose their safe seat on Daventry District Council.