Wixams Parish Council has asked two councillors to resign after a vote of no confidence was held.