Newlywed Ben Mullany who was shot with his wife on their honeymoon in Antigua has died, the hospital treating him has said.