Trade unions are being asked to suspend any plans for strike action by council workers after local government leaders tabled a new pay offer.