Politicians from across the political spectrum should seize the opportunity to overhaul the House of Lords once and for all, Lib Dem leader Tim Farron has said.