St. Paul's public works chief resigns under fire