Celebrities are signing up for the adult streaming site to do everything from drop albums to sell explicit photos and videos