Defo, it's worth doing a lesson even if it's just a taster up at Pinkston to see how you get on. Glasgow Paddleboarders Co are great and there's some wee independent companies too.
White loch is good to learn on as its fairly sheltered and small. Just keep away from the outflow, there's a pull in the water from it.