'I was Whitney Houston's bodyguard... But when she laid her head on my shoulder I was tempted to give up everything': British ex-cop who inspired Kevin Costner's character in the hit film reveals just how close they were and his one regret