Amber Heard’s friend says Johnny Depp told him about blacking out and passing out face first in the sand in the Bahamas and staff having to whisk his kids away