I'm looking at a possible relocate to Greenville, SC. Who lives near there and what's the boating and beach situation like?

We are water people so clean lakes for swimming and watersports are what we would want nearby. What are the names of some of the lakes?

Ken