The dam is just upstream from the ramp at Boonesboro within sight. You can go downstream under the bridge but I dont know where Riptides is.
Riptides is off old Richmond road, I know you can boat there tie up eat drink and be mary, just not sure which ramp to use that doesn't have a lock to pass thru to get there.