[SPARK-4771][Docs] Document standalone cluster supervise mode

@tdas looks like streaming already refers to the supervise mode. The link from there is broken though.
Could you define what is meant by failure? How is failure detected. Non-zero exit code?