Demential patients and their carers in Scotland are facing a postcode lottery when it comes to access to support, a leading charity has warned.