Hi there!
I suggest you to start getting the puppy familiar with the animals for now. If you already have, carry on until about 8 - 10 months. At that age your BC will be fully phys. Mature and familiar with 'play herding' the animals.
I suggest for a first, to get him herding sheep, as ducks tend to be a bit violent for a starter. This may promote hostility in the future, while sheep are more meek and are easier for a first herd.
Anyhow, border collies are wonderfully versatile herding dogs and they have the herding instinct very deep inside them, so it would be no large problem to get your pup herding. It's brilliantly lucky that you have the facilities so close to hand.
I wish you a great time with your pup!