Is there any way to make this brick destroy after it gives 1 coin?

When you want to destroy it all you literally do is use the :Destroy() function. Also, I have added a debounce that basically makes sure the player only gets 1 coin instead of hundreds.

If this is what you were looking for please make sure to accept my answer

local debounce = true
script.Parent.Touched:connect(function(part) 
	if debounce then
		debounce = false
		if game.Players:findFirstChild(part.Parent.Name) then 
			local plr = game.Players:findFirstChild(part.Parent.Name) 
			plr.leaderstats.Coins.Value = plr.leaderstats.Coins.Value + 1
			script.Parent:Destroy()
		end 	
	end
end)