Yes, it does cause an acceleration, but in the opposite direction to the motion. An object travelling from left to right and slowing down is accelerating but to the left. For example, if the force slowing it down was a rocket then it would slow, stop, then accelerate to the left. It's always accelerating to the left, even when slowing down or stationary. Frictional forces generally depend on the relative motions of the two objects involved though, so in a specific case when the relative speeds drop to zero the frictional force drops to zero and the acceleration stops, rather than continuing in style of the rocket.