If you're only using Regent excursions you don't need a special visa and won't need to carry your passport (unless the local authorities decide to require it.) If you have your own visa to tour independently, you get your passport and keep it until final boarding the last day in St Petersburg. For any port that requires you to carry a passport you generally keep it until you depart.
Jim
