"The Holy Spirit transforms the soul, making it basically capable of taking in... the infinite streams of knowledge and love that flow within the Holy Trinity. Thus we are really "sharers in the divine nature" (2 Peter 1:4). This is a dignity so great that any earthly honor is insignificant beside it.

The Holy Spirit comes with His Seven Gifts. These make the soul capable of taking in the special lights and inspirations He sends in a much higher way than what is had in ordinary graces. We do not notice much of any effects from these Gifts until we have advanced rather far in the spiritual life, for great docility and purity of heart are needed.

On Pentecost the Holy Spirit came down visibly on the Apostles. He gave them the power to speak in strange tongues to the crowds that came to Jerusalem for that Feast. He also transformed them, from selfish and timid men into giants of courage and faith.

Taken from The Basic Catholic Catechism
PART FOUR: The Apostle's Creed VI-VIII
Eighth Article: "I believe in the Holy Spirit"

Who is the Holy Spirit

The Holy Spirit is God and the third Person of the Blessed Trinity.

The Holy Spirit is the Helper, the Paraclete, the Advocate, the Spirit of Truth, the Spirit of God, and the Spirit of Love.

From whom does the Holy Spirit proceed?

The Holy Spirit proceeds from the Father and the Son. The Holy Spirit does not proceed from the Father and the Son by spiritual generation. Only the Son proceeds from the Father by generation. This is one of the mysterious truths that we know only from revelation.

Is the Holy Spirit equal to the Father and the Son?

The Holy Spirit is equal to the Father and the Son, because He is God. Because of the oneness of nature in the Blessed Trinity, the Father is entirely in the Son and in the Holy Spirit; the Son is entirely in the Father and in the Holy Spirit; and the Holy Spirit is entirely in the Father and in the Son. No one of the three divine Persons is outside the other, for none precedes the other in eternity, nor surpasses the other in power, nor exceeds the other in any way. This indwelling of one divine Person in the others is called circumincession.

What does the Holy Spirit do for the salvation of mankind?

The Holy Ghost dwells in the Church as the source of its life and sanctifies souls through the gift of grace. Although the sanctification of mankind, like all other outward works of God, is performed by all three Persons of the Blessed Trinity, it is attributed to the Holy Ghost, the third Person. The sanctification of mankind is attributed to the Holy Ghost because He is the love of the Father and the Son and because the sanctification of man by grace shows forth God's boundless love.

The above Q&A is quoted from The Baltimore Catechism, Lesson 9.