Nigel Farage resigns as MP to fight by-election amid finances row