Prince Harry got high at Courteney Cox's house and the toilet "became a head"