Nicola Sturgeon can look forward to the publication of her memoir and a headline appearance at the Glasgow Comedy Festival after being cleared in a police investigation.