If you cast Curse of Leeches while it is night, you must still choose a target player, and that player must be a legal target as Curse of Leeches resolves. It enters the battlefield transformed and is not attached to that player.