A huge seafront development planned by a wealthy investor has been turned down.