In Macintosh Leopard can I make a network storage drive LOOK like it's a physical external device?

No, you can't trick Leopard into thinking it's a USB or Firewire drive. I think Time Machine currently is limited to those options, but future updates should expand those possibilities.