Former Labour MP says he feels "sad" and "devastated" as he stands down from role