The best cities in Scotland for a Mother's Day spa break have been named.