A Scottish council is facing a budget gap of close to £50m over the next three years, an audit has warned