Gabriel Netto, 20, was at a party with family and friends in Juiz de Fora, Brazil, when it is understood he became unconscious while swimming in the water.
His pals managed to pull him from the reservoir following a frantic 40-minute search but he was unresponsive.
But paramedics were unable to revive him and he was pronounced dead at the scene on Friday.
It is unclear what caused Gabriel to pass out in the water.
His sister Aline described him as her “friend, adviser and companion” in a touching tribute.
She said: “Today, I didn’t just lose a brother, I lost a part of my soul.
“A big part of me has gone with you, I was with you until the last minute of your life.
“I am forever grateful for our union. You were and always will be our Gabriel.
“This is the greatest pain I have ever experienced in my life.
“Losing my brother is losing part of my life, it’s seeing happiness disappear, the joy of existing.”
Gabriel had 1.7 million followers on TikTok, where he shared snippets of his life in the countryside and pranks he had pulled on his mum.
His sister continued: “With you, there was never a bad time. I will never forget the last smile you gave me before everything happened and I will never forget those 20 years I lived with you.
“Rest in peace, my brother, and watch over me if you can.
“I will be here, crying and praying for you, honouring our relationship, as well as your name and infinite legacy of love and friendship. I love you forever.”