An American tourist thought he was going to die after he was shot in the pool at his luxurious resort while caught in a gunfight between rival drug gangs which left two dead in Cancun last week.