When the Fed sells a bond, it's taking cash out of the system and exchanging it for a bond. In monetary terms, it's destroying cash. That's tightening. When the Treasury issues a bond, it swaps it for cash. Same as the Fed.
Whether the Treasury or the Fed sells a bond, it has the same monetary effect. The difference is the Treasury's issuance is twinned to public spending, making the net effect neutral. (When the Treasury spends it creates cash.) In the short term, however, when spending precedes issuance (or vice versa), the gross effects can be real.