Stormont’s leaders have thanked outgoing US special envoy Joe Kennedy for his commitment to Northern Ireland.