If I was using a USB Storage Device on the source Wii U, will I be able to use it on the target Wii U after the transfer has been completed?

Yes. After the Wii U to Wii U system transfer has been completed, simply connect your USB Storage Device to the target Wii U console. All save data, game data, and update data on the USB Storage Device will be available.