Paying off a collection account will not remove it from your credit reports, nor will it improve your credit scores. All that will happen is the balance will be updated to show that the account has been paid in full.
The collection will remain in your credit reports and your credit scores will still consider this information because it reflects your previous payment patterns and is predictive of future credit risk. Collection accounts will only disappear from your reports when they expire after seven years.