A state-of-the-art surf resort featuring a waterfront bar and luxury accommodation in the outskirts of Edinburgh is set to open this month.