The Steelers organization confirmed that Cowher has acquired a minority ownership stake and will serve as a special advisor to the front office