That's actually entirely up to the player. If you want the character to wake up there, that's cool. But they could just as easily wake up out in town or wherever they fell asleep.

It'd be kind of cool if they heard about this weird stuff happening at the castle and then only came to investigate to see if their room had changed too. :')