“Fundamental change” is needed to ensure public services remain affordable, Scotland’s national audit body has warned.