Pet dogs are set to be allowed on trams permanently in Greater Manchester after a trial was declared a “success”.