Can anyone translate the following into Spanish so that the Spanish fits without losing the meaning (a literal word for word translation won't work). I have the song on disc which will be needed to make it fit with the music:

Who's this magician, he brings you dreams of rainbows
Casting shadows through pink lace curtains on the floor
Who's this magician, he brings so many lovers
Flowers for your hair, thorns upon my floor

Yes you will tell me, some forgotten secret
But you, you are mute, and I cannot see
Yes you will tell me, some forgotten secret
The door it opens slowly and what was is not there

Come take my hand now to a place in the night
Where shadows meet the morning and greet daylight
Come take my hand now and show me where you've been
Open up your heart, show me the dream.

Many thanks.