Lib Dem Leader Ed Davey has claimed "time's up" for Rishi Sunak and his "appalling" Conservative government as he celebrated his party's gains in the local elections.