Try Highland, then take the road from there to Franklin. It runs next to Cullasaja Gorge and passes Bridal Veil Falls as well. Some detail here:
Also tour Transylvania County, it's loaded with waterfalls.
A great source for shooting waterfalls is the Waterfall Walks and Drives books by Mark Morrison:
Theres a book for the area you're wanting to see.