Some lenses have the motor in the lens (called USM for Canon and AF-S for Nikon) and some don't. The lenses that don't have a motor in them are driven by a motor in the camera body.
Not all Canon lenses have a motor in them, only some of them. The same is true for Nikon lenses.
Canon has introduced the EOS system and its EF lenses (dead for the old FD mount) in 1987. Since then, all Canon EF lenses have the AF motor built into the lens (not just USM lenses). There is no EOS body featuring an AF motor in the camera body. Communication between Canon lenses and cameras is purely electrical since 19 years.
Canon has been criticized in the past for switching the mount from FD to EF and Nikon users praised their never changing mount. On the other side, EF has offered the better AF drive system. Each Canon lens has an AF motor specifically designed for one lens which is located next to the element the motor has to drive. Big motors for big tele lenses and smaller ones for smaller lenses and without long mechanical transmissions. Nikon’s AF motor in the camera body has always been the same, no matter if it has to drive a huge tele lens or a small and light lens. It’s obvious which system performed faster by basic design. In addition, Canon offers ultrasonic motors (USM) which are silent and fast. In some cheaper lenses there is a simple version of USM (an ultrasonic micro motor). The “true†USM features a ring type motor and is even faster and allows full time manual override anytime (no switching to MF required), like for example the 100mm macro USM, all those white tele lenses and black L lenses.
Julian