A former Waterford county manager is receiving pension payments of €63,000 a year while earning over €100,000 in his new senior management position in Irish Water.