I guess it depends how much money, but if it were me, and I know its easy to say, I'd play for my favourite team. And, if you train hard and play hard, maybe the chances, and money, will come with your favourite team. On the other hand, if you make a go of it at the other team and get some recognition, maybe an opportunity will come at your favourite team later on. It's never an easy decision. Talk to the people that matter to you, friends and family, and maybe the coaches/administration/players at the 2 clubs and decide whats best for you. Go with your heart.
This choice is for you, and you alone to make. You must choose between money, and affinity. Would you rather make more money or would you rather wear the jersey of your favorite team proudly? Only you can know the answer to this question.