Leader of Ripon City Council stands down