Is there a chance to see the Kelpies on Rick's Best of Scotland tour?
Maybe if you took a taxi while the rest of the group is touring Stirling Castle? That looks like about as close as the tour gets. Otherwise, you could do it as a day trip from Glasgow or Edinburgh before/after the tour.
On my tour, pre Pandemic, we drove by the Kelpies close enough to snap a quick pic.