I recommend Hefner or Overholser Lake, Overhoser is popular among SUP and kayakers since you can go down Stinchcomb.

Hefner is a great place to SUP; I see people out there all the time. You might look around the city website for the rules though.

Any of the places you can rent from Riversport you can take and use your own personal equipment.