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: http://www.apug.org/forums/forum49/9046-bridal-veil-falls-n-c.html
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: http://www.waterfallwalks.com/
Theres a book for the area you're wanting to see.