An Indian magician who was lowered into a river while shackled in a bid to recreate Harry Houdini's world-famous trick has drowned, police confirmed.