Stirling Council chief predicts end of authority as we know it under major shake-up