If you get non SSD external USB drive, Y-cable is most probably needed although I reckon you could connect the Y-cable power into wall wart instead of WiiU. Another option with spinner discs is use enclosure with external power supply.
Never used SSD external with WiiU myself, but I'd guess...