Congress says after bagging 41 municipal council president posts and 1,006 councillor seats, it is now main opposition party in state