Walter Mazzarri is to leave Watford after Sunday's final game of the season at home to Manchester City.