The DRV2605L can be connected directly to the Xiao through the I²C bus, with the usual pull-up resistors. The motor, either ERM or LRA, connects directly to the DRV2605L.
I recommend using the Adafuit breakout board, as it includes the resistor, and pick the listed vibrating mini motor.
Have fun!