A British-born photographer held hostage by Al Qaida in Yemen has been killed in a failed rescue attempt, his sister has said.