Ex-Lib Dem candidate will not stand in Harrogate and Knaresborough at next election