The Double Fond in Paris has an entire drink menu with 'magic' names.
Flame drinks: 151 works great. The flame burns very clean unfortunately, therefore best suited for low light situations. Unless you're spitting fire.
I've got a routine for a drink that froths over on command.
Mirrored cups can create wonders.
I use LED glowing ice cubes that are always a hit. Particularly with women. And kids.
Layered drinks are visually stimulating, and can be 'magicy'.
I have a few coctail shaker ideas.
No reason for Absinthe to be out....
What specifically are you after? email me for more....