Ekman vortices and the centrifugal instability in counter-rotating cylindrical Couette flow