First of all, let's analyse the effect of the shaft in a particular circular cross-section. When the shaft of the motor rotates, it causes the water surrounding it to revolve around the shaft in a circular path. The flow rate of water near the shaft is more than that away from it. This is a consequence of viscosity of water.
According to the Bernoulli's equation:
$$P+\rho gh+\frac 1 2\rho v^2=\text{constant}$$
where $P$ is the pressure, $\rho$ is the density of the fluid, $g$ is the acceleration due to gravity, $h$ is the height and $v$ is the speed of flow; at a fixed height when the speed of flow increases the pressure decreases. As we have discussed earlier, the speed of flow is larger near the centre and less towards the periphery. So, the pressure near the shaft of the motor is small when compared to the pressure near the periphery.
As an illustration, the pressure of a particular layer as viewed from the top looks something like the following image:

Due to this pressure difference, a particle away from the axis experiences a force towards the centre. Now let's come to your question:
Why does spinning water lift its contents?
The reason is almost similar to why tornados lift cars, trucks, etc. In tornados the active fluid is mostly air, however here it's water.
The speed of flow of water decreases from the top to the bottom because of viscosity effects. Or in other words, water near the top flows faster than water near the bottom. Due to this speed difference, as discussed before, there exists a pressure difference along the vertical column. The pressure near the top is less than the pressure near the bottom. This pressure difference looks something like the following image:

The pressure difference produces lift and hence causes the contents near the bottom to rise above. The object rises up until it's weight is balanced by the lift due to differential pressure on its top and bottom and the buoyant force.
The following diagram shows the order of pressures at two annular regions at two different heights:

The contents near the bottom rise and due to fluid's rotation these gain some speed in the horizontal direction. The centripetal force required to maintain the circular motion is provided by the differential pressure in the cross section as we discussed in the beginning of the answer. This is why the objects execute an approximate circular motion.