Yemen's president has reached an agreement with Houthi rebels to end a violent standoff in the capital Sana'a and to prevent further escalations.