Former Scottish first minister Nicola Sturgeon has led the tributes to “incredibly kind” comedian Janey Godley after she died aged 63.