We keep the water on the headboard in bottles. Hopefully they are large enough (Gatorade bottles) that the kitties won't knock them onto our heads.
In our house, the worst way to be woken up by Ginger is a claw stuck deep into either the side of my big toe, or the bottom of my foot.
She just wants to play "Munsterz Under the Blankie" and doesn't get it that if there's only one layer on Meowmy, her claws go right through.
Earl would argue (and win!) that the worst way he's been woken up is when Trent has jumped off our 6' tall bookcase headboard and landed on his...well, um...lower abdominal area.
Thankfully, Trent has only done that a couple times, and only once on purpose because he was mad at Daddy.
(It wasn't funny to him, but I about died laughing!)