“His greatest joy was making other people happy, and it was an honour to be alongside him as he did it,” Styles wrote a day after Payne’s death