That would depend on the drive. If the drive gets power through the Mac (bus-powered), then the drive should always power down when the Mac is sleeping. But, if the drive is self-powered (with its own power supply), then it depends on the drive's firmware. Some self-powered drives do not ever spin down, unless actually unplugged from power.