The Scottish Prison Service faces profound challenges in continuing to run Scotland's overcrowded prisons safely and effectively, says the Auditor General.