Southampton City Council “cannot afford to take its eye off the ball” despite showing signs of progress in addressing its financial plight, a report has said