'I'm pleased to announce that we're taking our military cooperation to even greater heights by formally designating Saudi Arabia as a major non-NATO ally,' says US president