Nigel Farage's Brexit Party has failed to win council seats in its first attempt at fielding candidates in local by-elections - leaving the anti-Brexit party the Liberal Democrats victorious.