It will be profitable either way if you somehow manage to get people visit your website as most of the faucets pay such small amounts of bitcoin that it just can't be not profitable for the owner. However the fact that it is just a waste of time nowadays will mean that you will not get a lot of people thus you will not be able to make a living out of it. As for the initial investment 10 dollars should be definitely enough.